package com.ocom.payhandle.dao;


import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.ocom.common.dto.PerInfoDto;
import com.ocom.common.entity.human.EntityPersonnelInfo;
import com.ocom.common.vo.payconfig.PersonAndDeptVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;


@Mapper
public interface IDaoPersonnelInfo extends BaseMapper<EntityPersonnelInfo> {

    @Select("select p.p_id  , p.dept_id ,p.p_code,p.p_name,d.dept_name " +
            "from personnel_info  p left  join  dept_info d on p.com_id =d.com_id  and p.dept_id =d.dept_id  ${ew.customSqlSegment}")
    public PersonAndDeptVo selectPerson(@Param(Constants.WRAPPER) Wrapper wrapper);
}
